SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [GOOGLECODERS].[Rubros](
	[IdRubro] [int] Primary key Identity(1,1),
	[Descripcion] [varchar](255) COLLATE Modern_Spanish_CI_AS NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

SET IDENTITY_INSERT [GOOGLECODERS].[Rubros] ON
INSERT INTO [GD2C2011].[GOOGLECODERS].[Rubros]
           ( [IdRubro]
			,[Descripcion]
			)  
	
SELECT DISTINCT 
	   [BENEFICIARIO_RUBRO_CODIGO]
      ,[BENEFICIARIO_RUBRO_DESC]
  FROM [GD2C2011].[gd_eschema].[Maestra]
WHERE BENEFICIARIO_RUBRO_CODIGO <> 0

SET IDENTITY_INSERT [GOOGLECODERS].[Rubros] OFF
